<?php
require ( "includes/config.php" );
require ( "includes/CGI.php" );
require ( "includes/SQL.php" );

$cgi = new CGI ();
$sql = new SQL ( $DBusername, $DBpassword, $server, $database );

if ( ! $sql->isConnected () )
{
  die ( $DatabaseError );
}

require ( "includes/CSQL.php" ); 
require ( "includes/lang/" . $language_pack . "/index.php" );

// Get the property locations from the database and display them in alpha order
    {        
    $rows = $sql->execute ( "SELECT * FROM " . $propertylocations_table .
      " ORDER BY propertylocation ASC", SQL_RETURN_ASSOC );

    $num = sizeof ( $rows );      
      for ( $i = 0; $i < $num; ++$i )
      {
        $id = $rows [ $i ] [ "id" ];
        $propertylocation = $rows [ $i ] [ "propertylocation" ];
  echo "<img src=\"includes/images/arrow_blue.gif\" width=\"10\" height=\"13\">&nbsp;&nbsp;<a href=\"$template_page_name?op=search&pl=$id\">$propertylocation</a><br>";        
 }
  }
  
?>